Release 10.1A: OpenEdge Data Management:
SQL Reference

HOUR

Returns the hour in the argument as a short integer value in the range of 0–23.

Syntax

HOUR ( time_expression )

Example

This example illustrates the HOUR function:

SELECT *     FROM arrivals     WHERE HOUR (in_time) < 12 ;

Notes

The argument to the function must be of type TIME.
The argument must be specified in the format hh:mi:ss.
The result is of type SHORT.
If the argument expression evaluates to NULL, the result is NULL.

Compatibility

ODBC compatible